GrapeCity.CalcEngine.Functions Namespace > CalcIndexFunction Class > Evaluate Method : Evaluate(Object[],Object) Method |
The args contains 2 - 4 items: array, row_num, [column_num], [Area_num].
Array is a range of cells or an array constant.
Row_num selects the row in array from which to return a value. If row_num is omitted, column_num is required.
[Column_num] selects the column in array from which to return a value. If column_num is omitted, row_num is required.
[Area_num] selects a range in reference from which to return the intersection of row_num and column_num.'Declaration Public Overloads Overrides Function Evaluate( _ ByVal args() As System.Object, _ ByVal context As System.Object _ ) As System.Object
'Usage Dim instance As CalcIndexFunction Dim args() As System.Object Dim context As System.Object Dim value As System.Object value = instance.Evaluate(args, context)
The args contains 2 - 4 items: array, row_num, [column_num], [Area_num].
Array is a range of cells or an array constant.
Row_num selects the row in array from which to return a value. If row_num is omitted, column_num is required.
[Column_num] selects the column in array from which to return a value. If column_num is omitted, row_num is required.
[Area_num] selects a range in reference from which to return the intersection of row_num and column_num.Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6